package com.car.dao;

import com.car.entity.Billing;
import com.car.entity.Car;
import com.car.entity.FindVip;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository("billingMapper")
public interface BillingMapper {
    List<Billing> findBilling();
    int deleteBilling(int bid);
    int deleteVip(int bid);
    Billing findByIdBilling(int vid);
    List<Billing> findByIdPname(int vid);
    List<Billing> findByIdSname(int vid);
    int deleteSnamePname(int bid);


    int addSname(Billing billing);
    int addEmpEname(Billing billing);
    int addPname(Billing billing);

    List<Billing> findBybilling(String regtime,String jieshu,String phone);
    int updateBilling(Billing billing);

    List<FindVip> findVip(int wid);
    List<FindVip> findCar(int wid);
    int findByVip(String name);
    int updateMileage(FindVip findVip);

    Car findByIdCar(int cid);
    int updateCar(Car car);
    int addCar2(Car car);

    List<Billing> findEmpEname();
    List<Billing> findEmpPname();
}